{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='起亚')]\n",
    "LSG_price = LSG_price[LSG_price['factory']!='起亚']\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口起亚>>']\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LJD')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>YQZ7146ADE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1060</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>1368</td>\n",
       "      <td>70</td>\n",
       "      <td>LJD0AA29×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>焕驰</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>YQZ7146E5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1020</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>1368</td>\n",
       "      <td>70</td>\n",
       "      <td>LJD0AA29×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>焕驰</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>YQZ7146DE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1020</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>1368</td>\n",
       "      <td>70</td>\n",
       "      <td>LJD0AA29×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>焕驰</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>YQZ7146AE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1060</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>1368</td>\n",
       "      <td>70</td>\n",
       "      <td>LJD0AA29×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>焕驰</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>YQZ7146ADE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1060</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>1368</td>\n",
       "      <td>70</td>\n",
       "      <td>LJD0AA29×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>焕驰</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>YQZ7146E5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1020</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>1368</td>\n",
       "      <td>70</td>\n",
       "      <td>LJD0AA29×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>焕驰</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>YQZ7146DE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1020</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>1368</td>\n",
       "      <td>70</td>\n",
       "      <td>LJD0AA29×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>焕驰</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>YQZ7146AE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1060</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>1368</td>\n",
       "      <td>70</td>\n",
       "      <td>LJD0AA29×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2570</td>\n",
       "      <td>4300x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>焕驰</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>YQZ7145CE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1125</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1368</td>\n",
       "      <td>73.3</td>\n",
       "      <td>LJDYAA19×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>YQZ7145ACDE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1145</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1368</td>\n",
       "      <td>73.3</td>\n",
       "      <td>LJDYAA19×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>YQZ7162ACDE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1175</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LJDYAA12×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>YQZ7145ACE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1145</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1368</td>\n",
       "      <td>73.3</td>\n",
       "      <td>LJDYAA19×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>YQZ7162ACE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1175</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LJDYAA12×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>YQZ7145CDE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1125</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1368</td>\n",
       "      <td>73.3</td>\n",
       "      <td>LJDYAA19×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>YQZ7145ACE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1145</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1368</td>\n",
       "      <td>73.3</td>\n",
       "      <td>LJDYAA19×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>YQZ7162ACDE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1175</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LJDYAA12×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>YQZ7145ACDE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1145</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1368</td>\n",
       "      <td>73.3</td>\n",
       "      <td>LJDYAA19×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>YQZ7145CE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1125</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1368</td>\n",
       "      <td>73.3</td>\n",
       "      <td>LJDYAA19×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>YQZ7145CDE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1125</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1368</td>\n",
       "      <td>73.3</td>\n",
       "      <td>LJDYAA19×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>YQZ7162ACE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1175</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LJDYAA12×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>YQZ7183APGE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1450</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LJDTAA23×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720x1815x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>凯绅</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>YQZ7183APE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1380</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LJDTAA23×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720x1815x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>凯绅</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>YQZ7160TPDE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1465</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>1591</td>\n",
       "      <td>128.7</td>\n",
       "      <td>LJDTAA22×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720x1815x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>凯绅</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>YQZ7183APDE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1380</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LJDTAA23×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720x1815x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>凯绅</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>YQZ7183APGDE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1450</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LJDTAA23×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720x1815x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>凯绅</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>YQZ7160TPE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1465</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>1591</td>\n",
       "      <td>128.7</td>\n",
       "      <td>LJDTAA22×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720x1815x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>凯绅</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>YQZ7183</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1358</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LJDPAA22×××××××××,LJDTAA23×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720x1815x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>凯绅</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>YQZ7160T</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1495</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>1591</td>\n",
       "      <td>128.7</td>\n",
       "      <td>LJDPAA22×××××××××,LJDTAA22×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720x1815x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>凯绅</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>YQZ7183AME5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1459</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LJDPAA22×××××××××,LJDTAA23×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720x1815x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>凯绅</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>YQZ7160TE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1495</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>1591</td>\n",
       "      <td>128.7</td>\n",
       "      <td>LJDPAA22×××××××××,LJDTAA22×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2770</td>\n",
       "      <td>4720x1815x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>凯绅</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>YQZ7200AE3</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1515</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LJDCAA24×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>YQZ7200E3</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1500</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LJDCAA24×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316</th>\n",
       "      <td>YQZ7180CNG</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1521</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1795</td>\n",
       "      <td>94</td>\n",
       "      <td>LJDCAA2B×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>YQZ7200AEF</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1515</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LJDCAA24×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>YQZ7200EF</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1500</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LJDCAA24×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>YQZ7180EF</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1475</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1795</td>\n",
       "      <td>94</td>\n",
       "      <td>LJDCAA23×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>YQZ7180LE</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1515</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1795</td>\n",
       "      <td>94</td>\n",
       "      <td>LJDCAA27×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>YQZ7180E3</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1475</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1795</td>\n",
       "      <td>94</td>\n",
       "      <td>LJDCAA23×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>YQZ7200AE3</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1515</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LJDCAA24×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>YQZ7200E3</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1500</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LJDCAA24×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>YQZ7180E3</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1475</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1795</td>\n",
       "      <td>94</td>\n",
       "      <td>LJDCAA23×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>YQZ7200A</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1515</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LJDCAA24×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>YQZ7200</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1500</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LJDCAA24×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>YQZ7180</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1475</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1795</td>\n",
       "      <td>94</td>\n",
       "      <td>LJDCAA23×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>YQZ7180L</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1503</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1795</td>\n",
       "      <td>94</td>\n",
       "      <td>LJDCAA27×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>YQZ7180A</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1490</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1795</td>\n",
       "      <td>94</td>\n",
       "      <td>LJDBAA37×××××××××\\r,LJDCAA23×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330</th>\n",
       "      <td>YQZ7130CNG</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1069</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115</td>\n",
       "      <td>1620</td>\n",
       "      <td>1410</td>\n",
       "      <td>1341</td>\n",
       "      <td>61.1</td>\n",
       "      <td>LJDAAA28×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115x1620x1410</td>\n",
       "      <td>起亚</td>\n",
       "      <td>千里马</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>YQZ7131</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1010</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115</td>\n",
       "      <td>1620</td>\n",
       "      <td>1410</td>\n",
       "      <td>1341</td>\n",
       "      <td>61.1</td>\n",
       "      <td>LJDBAA33×××××××××LJDAAA21×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115x1620x1410</td>\n",
       "      <td>起亚</td>\n",
       "      <td>千里马</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>YQZ7160</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1025</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115</td>\n",
       "      <td>1620</td>\n",
       "      <td>1410</td>\n",
       "      <td>1599</td>\n",
       "      <td>76.5</td>\n",
       "      <td>LJDBAA34×××××××××\\r,LJDAAA22×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115x1620x1410</td>\n",
       "      <td>起亚</td>\n",
       "      <td>千里马</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>333</th>\n",
       "      <td>YQZ7161</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1025</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115</td>\n",
       "      <td>1620</td>\n",
       "      <td>1410</td>\n",
       "      <td>1599</td>\n",
       "      <td>76.5</td>\n",
       "      <td>LJDBAA34×××××××××\\r,LJDAAA22×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115x1620x1410</td>\n",
       "      <td>起亚</td>\n",
       "      <td>千里马</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>334</th>\n",
       "      <td>YQZ7161AE3</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1035</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115</td>\n",
       "      <td>1620</td>\n",
       "      <td>1410</td>\n",
       "      <td>1599</td>\n",
       "      <td>76.5</td>\n",
       "      <td>LJDAAA22×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115x1620x1410</td>\n",
       "      <td>起亚</td>\n",
       "      <td>千里马</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335</th>\n",
       "      <td>YQZ7161A</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1035</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115</td>\n",
       "      <td>1620</td>\n",
       "      <td>1410</td>\n",
       "      <td>1599</td>\n",
       "      <td>76.5</td>\n",
       "      <td>LJDBAA34×××××××××\\r,LJDAAA22×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115x1620x1410</td>\n",
       "      <td>起亚</td>\n",
       "      <td>千里马</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>336</th>\n",
       "      <td>YQZ7130</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1010</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115</td>\n",
       "      <td>1620</td>\n",
       "      <td>1410</td>\n",
       "      <td>1341</td>\n",
       "      <td>61.1</td>\n",
       "      <td>LJDBAA33×××××××××\\r,LJDAAA21×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115x1620x1410</td>\n",
       "      <td>起亚</td>\n",
       "      <td>千里马</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>YQZ7130A</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1030</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115</td>\n",
       "      <td>1620</td>\n",
       "      <td>1410</td>\n",
       "      <td>1341</td>\n",
       "      <td>61.1</td>\n",
       "      <td>LJDBAA33×××××××××\\r,LJDAAA21×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115x1620x1410</td>\n",
       "      <td>起亚</td>\n",
       "      <td>千里马</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338</th>\n",
       "      <td>YQZ7131A</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1030</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115</td>\n",
       "      <td>1620</td>\n",
       "      <td>1410</td>\n",
       "      <td>1341</td>\n",
       "      <td>61.1</td>\n",
       "      <td>LJDBAA33×××××××××\\r,LJDAAA21×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115x1620x1410</td>\n",
       "      <td>起亚</td>\n",
       "      <td>千里马</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>339</th>\n",
       "      <td>YQZ7160A</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1035</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115</td>\n",
       "      <td>1620</td>\n",
       "      <td>1410</td>\n",
       "      <td>1599</td>\n",
       "      <td>76.5</td>\n",
       "      <td>LJDBAA34×××××××××\\r,LJDAAA22×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2400</td>\n",
       "      <td>4115x1620x1410</td>\n",
       "      <td>起亚</td>\n",
       "      <td>千里马</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>YQZ6441AWE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1580</td>\n",
       "      <td>2640</td>\n",
       "      <td>4450</td>\n",
       "      <td>1855</td>\n",
       "      <td>1660</td>\n",
       "      <td>2359</td>\n",
       "      <td>128</td>\n",
       "      <td>LJDJAC1E×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2640</td>\n",
       "      <td>4450x1855x1660</td>\n",
       "      <td>起亚</td>\n",
       "      <td>智跑</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341</th>\n",
       "      <td>YQZ6441AWE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1540</td>\n",
       "      <td>2640</td>\n",
       "      <td>4440</td>\n",
       "      <td>1855</td>\n",
       "      <td>1660</td>\n",
       "      <td>2359</td>\n",
       "      <td>128</td>\n",
       "      <td>LJDJAC1E×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2640</td>\n",
       "      <td>4440x1855x1660</td>\n",
       "      <td>起亚</td>\n",
       "      <td>智跑</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>YQZ6441AWE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1540</td>\n",
       "      <td>2640</td>\n",
       "      <td>4440</td>\n",
       "      <td>1855</td>\n",
       "      <td>1660</td>\n",
       "      <td>2359</td>\n",
       "      <td>128</td>\n",
       "      <td>LJDJAC1E×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2640</td>\n",
       "      <td>4440x1855x1660</td>\n",
       "      <td>起亚</td>\n",
       "      <td>智跑</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343</th>\n",
       "      <td>YQZ6441AWE5</td>\n",
       "      <td>起亚</td>\n",
       "      <td>1540</td>\n",
       "      <td>2640</td>\n",
       "      <td>4440</td>\n",
       "      <td>1855</td>\n",
       "      <td>1660</td>\n",
       "      <td>2359</td>\n",
       "      <td>128</td>\n",
       "      <td>LJDJAC1E×××××××××</td>\n",
       "      <td>东风悦达起亚汽车有限公司</td>\n",
       "      <td>LJD</td>\n",
       "      <td>2640</td>\n",
       "      <td>4440x1855x1660</td>\n",
       "      <td>起亚</td>\n",
       "      <td>智跑</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>344 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0      YQZ7146ADE5      起亚        1060      2570       4300      1700   \n",
       "1        YQZ7146E5      起亚        1020      2570       4300      1700   \n",
       "2       YQZ7146DE5      起亚        1020      2570       4300      1700   \n",
       "3       YQZ7146AE5      起亚        1060      2570       4300      1700   \n",
       "4      YQZ7146ADE5      起亚        1060      2570       4300      1700   \n",
       "5        YQZ7146E5      起亚        1020      2570       4300      1700   \n",
       "6       YQZ7146DE5      起亚        1020      2570       4300      1700   \n",
       "7       YQZ7146AE5      起亚        1060      2570       4300      1700   \n",
       "8       YQZ7145CE5      起亚        1125      2600       4240      1750   \n",
       "9     YQZ7145ACDE5      起亚        1145      2600       4240      1750   \n",
       "10    YQZ7162ACDE5      起亚        1175      2600       4240      1750   \n",
       "11     YQZ7145ACE5      起亚        1145      2600       4240      1750   \n",
       "12     YQZ7162ACE5      起亚        1175      2600       4240      1750   \n",
       "13     YQZ7145CDE5      起亚        1125      2600       4240      1750   \n",
       "14     YQZ7145ACE5      起亚        1145      2600       4240      1750   \n",
       "15    YQZ7162ACDE5      起亚        1175      2600       4240      1750   \n",
       "16    YQZ7145ACDE5      起亚        1145      2600       4240      1750   \n",
       "17      YQZ7145CE5      起亚        1125      2600       4240      1750   \n",
       "18     YQZ7145CDE5      起亚        1125      2600       4240      1750   \n",
       "19     YQZ7162ACE5      起亚        1175      2600       4240      1750   \n",
       "20    YQZ7183APGE5      起亚        1450      2770       4720      1815   \n",
       "21     YQZ7183APE5      起亚        1380      2770       4720      1815   \n",
       "22    YQZ7160TPDE5      起亚        1465      2770       4720      1815   \n",
       "23    YQZ7183APDE5      起亚        1380      2770       4720      1815   \n",
       "24   YQZ7183APGDE5      起亚        1450      2770       4720      1815   \n",
       "25     YQZ7160TPE5      起亚        1465      2770       4720      1815   \n",
       "26         YQZ7183      起亚        1358      2770       4720      1815   \n",
       "27        YQZ7160T      起亚        1495      2770       4720      1815   \n",
       "28     YQZ7183AME5      起亚        1459      2770       4720      1815   \n",
       "29      YQZ7160TE5      起亚        1495      2770       4720      1815   \n",
       "..             ...     ...         ...       ...        ...       ...   \n",
       "314     YQZ7200AE3      起亚        1515      2700       4728      1820   \n",
       "315      YQZ7200E3      起亚        1500      2700       4728      1820   \n",
       "316     YQZ7180CNG      起亚        1521      2700       4728      1820   \n",
       "317     YQZ7200AEF      起亚        1515      2700       4728      1820   \n",
       "318      YQZ7200EF      起亚        1500      2700       4728      1820   \n",
       "319      YQZ7180EF      起亚        1475      2700       4728      1820   \n",
       "320      YQZ7180LE      起亚        1515      2700       4728      1820   \n",
       "321      YQZ7180E3      起亚        1475      2700       4728      1820   \n",
       "322     YQZ7200AE3      起亚        1515      2700       4728      1820   \n",
       "323      YQZ7200E3      起亚        1500      2700       4728      1820   \n",
       "324      YQZ7180E3      起亚        1475      2700       4728      1820   \n",
       "325       YQZ7200A      起亚        1515      2700       4728      1820   \n",
       "326        YQZ7200      起亚        1500      2700       4728      1820   \n",
       "327        YQZ7180      起亚        1475      2700       4728      1820   \n",
       "328       YQZ7180L      起亚        1503      2700       4728      1820   \n",
       "329       YQZ7180A      起亚        1490      2700       4728      1820   \n",
       "330     YQZ7130CNG      起亚        1069      2400       4115      1620   \n",
       "331        YQZ7131      起亚        1010      2400       4115      1620   \n",
       "332        YQZ7160      起亚        1025      2400       4115      1620   \n",
       "333        YQZ7161      起亚        1025      2400       4115      1620   \n",
       "334     YQZ7161AE3      起亚        1035      2400       4115      1620   \n",
       "335       YQZ7161A      起亚        1035      2400       4115      1620   \n",
       "336        YQZ7130      起亚        1010      2400       4115      1620   \n",
       "337       YQZ7130A      起亚        1030      2400       4115      1620   \n",
       "338       YQZ7131A      起亚        1030      2400       4115      1620   \n",
       "339       YQZ7160A      起亚        1035      2400       4115      1620   \n",
       "340    YQZ6441AWE5      起亚        1580      2640       4450      1855   \n",
       "341    YQZ6441AWE5      起亚        1540      2640       4440      1855   \n",
       "342    YQZ6441AWE5      起亚        1540      2640       4440      1855   \n",
       "343    YQZ6441AWE5      起亚        1540      2640       4440      1855   \n",
       "\n",
       "    car_height Displacement  power                                    vin  \\\n",
       "0         1460         1368     70                      LJD0AA29×××××××××   \n",
       "1         1460         1368     70                      LJD0AA29×××××××××   \n",
       "2         1460         1368     70                      LJD0AA29×××××××××   \n",
       "3         1460         1368     70                      LJD0AA29×××××××××   \n",
       "4         1460         1368     70                      LJD0AA29×××××××××   \n",
       "5         1460         1368     70                      LJD0AA29×××××××××   \n",
       "6         1460         1368     70                      LJD0AA29×××××××××   \n",
       "7         1460         1368     70                      LJD0AA29×××××××××   \n",
       "8         1505         1368   73.3                      LJDYAA19×××××××××   \n",
       "9         1505         1368   73.3                      LJDYAA19×××××××××   \n",
       "10        1505         1591   90.2                      LJDYAA12×××××××××   \n",
       "11        1505         1368   73.3                      LJDYAA19×××××××××   \n",
       "12        1505         1591   90.2                      LJDYAA12×××××××××   \n",
       "13        1505         1368   73.3                      LJDYAA19×××××××××   \n",
       "14        1505         1368   73.3                      LJDYAA19×××××××××   \n",
       "15        1505         1591   90.2                      LJDYAA12×××××××××   \n",
       "16        1505         1368   73.3                      LJDYAA19×××××××××   \n",
       "17        1505         1368   73.3                      LJDYAA19×××××××××   \n",
       "18        1505         1368   73.3                      LJDYAA19×××××××××   \n",
       "19        1505         1591   90.2                      LJDYAA12×××××××××   \n",
       "20        1465         1797    105                      LJDTAA23×××××××××   \n",
       "21        1465         1797    105                      LJDTAA23×××××××××   \n",
       "22        1465         1591  128.7                      LJDTAA22×××××××××   \n",
       "23        1465         1797    105                      LJDTAA23×××××××××   \n",
       "24        1465         1797    105                      LJDTAA23×××××××××   \n",
       "25        1465         1591  128.7                      LJDTAA22×××××××××   \n",
       "26        1465         1797    105    LJDPAA22×××××××××,LJDTAA23×××××××××   \n",
       "27        1465         1591  128.7    LJDPAA22×××××××××,LJDTAA22×××××××××   \n",
       "28        1465         1797    105    LJDPAA22×××××××××,LJDTAA23×××××××××   \n",
       "29        1465         1591  128.7    LJDPAA22×××××××××,LJDTAA22×××××××××   \n",
       "..         ...          ...    ...                                    ...   \n",
       "314       1420         1975    101                      LJDCAA24×××××××××   \n",
       "315       1420         1975    101                      LJDCAA24×××××××××   \n",
       "316       1420         1795     94                      LJDCAA2B×××××××××   \n",
       "317       1420         1975    101                      LJDCAA24×××××××××   \n",
       "318       1420         1975    101                      LJDCAA24×××××××××   \n",
       "319       1420         1795     94                      LJDCAA23×××××××××   \n",
       "320       1420         1795     94                      LJDCAA27×××××××××   \n",
       "321       1420         1795     94                      LJDCAA23×××××××××   \n",
       "322       1420         1975    101                      LJDCAA24×××××××××   \n",
       "323       1420         1975    101                      LJDCAA24×××××××××   \n",
       "324       1420         1795     94                      LJDCAA23×××××××××   \n",
       "325       1420         1975    101                      LJDCAA24×××××××××   \n",
       "326       1420         1975    101                      LJDCAA24×××××××××   \n",
       "327       1420         1795     94                      LJDCAA23×××××××××   \n",
       "328       1420         1795     94                      LJDCAA27×××××××××   \n",
       "329       1420         1795     94  LJDBAA37×××××××××\\r,LJDCAA23×××××××××   \n",
       "330       1410         1341   61.1                      LJDAAA28×××××××××   \n",
       "331       1410         1341   61.1     LJDBAA33×××××××××LJDAAA21×××××××××   \n",
       "332       1410         1599   76.5  LJDBAA34×××××××××\\r,LJDAAA22×××××××××   \n",
       "333       1410         1599   76.5  LJDBAA34×××××××××\\r,LJDAAA22×××××××××   \n",
       "334       1410         1599   76.5                      LJDAAA22×××××××××   \n",
       "335       1410         1599   76.5  LJDBAA34×××××××××\\r,LJDAAA22×××××××××   \n",
       "336       1410         1341   61.1  LJDBAA33×××××××××\\r,LJDAAA21×××××××××   \n",
       "337       1410         1341   61.1  LJDBAA33×××××××××\\r,LJDAAA21×××××××××   \n",
       "338       1410         1341   61.1  LJDBAA33×××××××××\\r,LJDAAA21×××××××××   \n",
       "339       1410         1599   76.5  LJDBAA34×××××××××\\r,LJDAAA22×××××××××   \n",
       "340       1660         2359    128                      LJDJAC1E×××××××××   \n",
       "341       1660         2359    128                      LJDJAC1E×××××××××   \n",
       "342       1660         2359    128                      LJDJAC1E×××××××××   \n",
       "343       1660         2359    128                      LJDJAC1E×××××××××   \n",
       "\n",
       "      car_factory    3 轴距[mm]       长×宽×高[mm] brand_y       style  factory  \n",
       "0    东风悦达起亚汽车有限公司  LJD   2570  4300x1700x1460      起亚          焕驰        5  \n",
       "1    东风悦达起亚汽车有限公司  LJD   2570  4300x1700x1460      起亚          焕驰        5  \n",
       "2    东风悦达起亚汽车有限公司  LJD   2570  4300x1700x1460      起亚          焕驰        5  \n",
       "3    东风悦达起亚汽车有限公司  LJD   2570  4300x1700x1460      起亚          焕驰        5  \n",
       "4    东风悦达起亚汽车有限公司  LJD   2570  4300x1700x1460      起亚          焕驰        5  \n",
       "5    东风悦达起亚汽车有限公司  LJD   2570  4300x1700x1460      起亚          焕驰        5  \n",
       "6    东风悦达起亚汽车有限公司  LJD   2570  4300x1700x1460      起亚          焕驰        5  \n",
       "7    东风悦达起亚汽车有限公司  LJD   2570  4300x1700x1460      起亚          焕驰        5  \n",
       "8    东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "9    东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "10   东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "11   东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "12   东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "13   东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "14   东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "15   东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "16   东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "17   东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "18   东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "19   东风悦达起亚汽车有限公司  LJD   2600  4240x1750x1505      起亚  起亚KX CROSS        2  \n",
       "20   东风悦达起亚汽车有限公司  LJD   2770  4720x1815x1465      起亚          凯绅       24  \n",
       "21   东风悦达起亚汽车有限公司  LJD   2770  4720x1815x1465      起亚          凯绅       24  \n",
       "22   东风悦达起亚汽车有限公司  LJD   2770  4720x1815x1465      起亚          凯绅       24  \n",
       "23   东风悦达起亚汽车有限公司  LJD   2770  4720x1815x1465      起亚          凯绅       24  \n",
       "24   东风悦达起亚汽车有限公司  LJD   2770  4720x1815x1465      起亚          凯绅       24  \n",
       "25   东风悦达起亚汽车有限公司  LJD   2770  4720x1815x1465      起亚          凯绅       24  \n",
       "26   东风悦达起亚汽车有限公司  LJD   2770  4720x1815x1465      起亚          凯绅       24  \n",
       "27   东风悦达起亚汽车有限公司  LJD   2770  4720x1815x1465      起亚          凯绅       24  \n",
       "28   东风悦达起亚汽车有限公司  LJD   2770  4720x1815x1465      起亚          凯绅       24  \n",
       "29   东风悦达起亚汽车有限公司  LJD   2770  4720x1815x1465      起亚          凯绅       24  \n",
       "..            ...  ...    ...             ...     ...         ...      ...  \n",
       "314  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "315  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "316  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "317  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "318  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "319  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "320  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "321  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "322  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "323  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "324  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "325  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "326  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "327  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "328  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "329  东风悦达起亚汽车有限公司  LJD   2700  4728x1820x1420      起亚          远舰       45  \n",
       "330  东风悦达起亚汽车有限公司  LJD   2400  4115x1620x1410      起亚         千里马       60  \n",
       "331  东风悦达起亚汽车有限公司  LJD   2400  4115x1620x1410      起亚         千里马       60  \n",
       "332  东风悦达起亚汽车有限公司  LJD   2400  4115x1620x1410      起亚         千里马       60  \n",
       "333  东风悦达起亚汽车有限公司  LJD   2400  4115x1620x1410      起亚         千里马       60  \n",
       "334  东风悦达起亚汽车有限公司  LJD   2400  4115x1620x1410      起亚         千里马       60  \n",
       "335  东风悦达起亚汽车有限公司  LJD   2400  4115x1620x1410      起亚         千里马       60  \n",
       "336  东风悦达起亚汽车有限公司  LJD   2400  4115x1620x1410      起亚         千里马       60  \n",
       "337  东风悦达起亚汽车有限公司  LJD   2400  4115x1620x1410      起亚         千里马       60  \n",
       "338  东风悦达起亚汽车有限公司  LJD   2400  4115x1620x1410      起亚         千里马       60  \n",
       "339  东风悦达起亚汽车有限公司  LJD   2400  4115x1620x1410      起亚         千里马       60  \n",
       "340  东风悦达起亚汽车有限公司  LJD   2640  4450x1855x1660      起亚          智跑       13  \n",
       "341  东风悦达起亚汽车有限公司  LJD   2640  4440x1855x1660      起亚          智跑       28  \n",
       "342  东风悦达起亚汽车有限公司  LJD   2640  4440x1855x1660      起亚          智跑       28  \n",
       "343  东风悦达起亚汽车有限公司  LJD   2640  4440x1855x1660      起亚          智跑       28  \n",
       "\n",
       "[344 rows x 17 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('起亚_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Wheelbase</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2345</td>\n",
       "      <td>3615x1605x1394</td>\n",
       "      <td>起亚</td>\n",
       "      <td>普莱特</td>\n",
       "      <td>6</td>\n",
       "      <td>3615</td>\n",
       "      <td>1605</td>\n",
       "      <td>1394</td>\n",
       "      <td>2345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2345</td>\n",
       "      <td>3935x1605x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>普莱特</td>\n",
       "      <td>6</td>\n",
       "      <td>3935</td>\n",
       "      <td>1605</td>\n",
       "      <td>1465</td>\n",
       "      <td>2345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2400</td>\n",
       "      <td>4115x1620x1410</td>\n",
       "      <td>起亚</td>\n",
       "      <td>千里马</td>\n",
       "      <td>60</td>\n",
       "      <td>4115</td>\n",
       "      <td>1620</td>\n",
       "      <td>1410</td>\n",
       "      <td>2400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2500</td>\n",
       "      <td>4290x1695x1480</td>\n",
       "      <td>起亚</td>\n",
       "      <td>锐欧</td>\n",
       "      <td>18</td>\n",
       "      <td>4290</td>\n",
       "      <td>1695</td>\n",
       "      <td>1480</td>\n",
       "      <td>2500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2550</td>\n",
       "      <td>4096x1785x1663</td>\n",
       "      <td>起亚</td>\n",
       "      <td>秀尔</td>\n",
       "      <td>16</td>\n",
       "      <td>4096</td>\n",
       "      <td>1785</td>\n",
       "      <td>1663</td>\n",
       "      <td>2550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2570</td>\n",
       "      <td>4120x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚K2</td>\n",
       "      <td>10</td>\n",
       "      <td>4120</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>2570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2570</td>\n",
       "      <td>4128x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚K2</td>\n",
       "      <td>6</td>\n",
       "      <td>4128</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>2570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2570</td>\n",
       "      <td>4300x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>焕驰</td>\n",
       "      <td>5</td>\n",
       "      <td>4300</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>2570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2570</td>\n",
       "      <td>4370x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚K2</td>\n",
       "      <td>15</td>\n",
       "      <td>4370</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>2570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2570</td>\n",
       "      <td>4378x1700x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚K2</td>\n",
       "      <td>7</td>\n",
       "      <td>4378</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>2570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2590</td>\n",
       "      <td>4270x1780x1630</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX3</td>\n",
       "      <td>5</td>\n",
       "      <td>4270</td>\n",
       "      <td>1780</td>\n",
       "      <td>1630</td>\n",
       "      <td>2590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2590</td>\n",
       "      <td>4270x1780x1645</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX3</td>\n",
       "      <td>12</td>\n",
       "      <td>4270</td>\n",
       "      <td>1780</td>\n",
       "      <td>1645</td>\n",
       "      <td>2590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2600</td>\n",
       "      <td>4240x1750x1505</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX CROSS</td>\n",
       "      <td>2</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2610</td>\n",
       "      <td>4500x1735x1470</td>\n",
       "      <td>起亚</td>\n",
       "      <td>赛拉图</td>\n",
       "      <td>48</td>\n",
       "      <td>4500</td>\n",
       "      <td>1735</td>\n",
       "      <td>1470</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2630</td>\n",
       "      <td>4350x1840x1730</td>\n",
       "      <td>起亚</td>\n",
       "      <td>狮跑</td>\n",
       "      <td>42</td>\n",
       "      <td>4350</td>\n",
       "      <td>1840</td>\n",
       "      <td>1730</td>\n",
       "      <td>2630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2640</td>\n",
       "      <td>4440x1855x1635</td>\n",
       "      <td>起亚</td>\n",
       "      <td>智跑</td>\n",
       "      <td>8</td>\n",
       "      <td>4440</td>\n",
       "      <td>1855</td>\n",
       "      <td>1635</td>\n",
       "      <td>2640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2640</td>\n",
       "      <td>4440x1855x1660</td>\n",
       "      <td>起亚</td>\n",
       "      <td>智跑</td>\n",
       "      <td>28</td>\n",
       "      <td>4440</td>\n",
       "      <td>1855</td>\n",
       "      <td>1660</td>\n",
       "      <td>2640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2640</td>\n",
       "      <td>4450x1855x1660</td>\n",
       "      <td>起亚</td>\n",
       "      <td>智跑</td>\n",
       "      <td>13</td>\n",
       "      <td>4450</td>\n",
       "      <td>1855</td>\n",
       "      <td>1660</td>\n",
       "      <td>2640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2640</td>\n",
       "      <td>4460x1850x1695</td>\n",
       "      <td>起亚</td>\n",
       "      <td>智跑</td>\n",
       "      <td>2</td>\n",
       "      <td>4460</td>\n",
       "      <td>1850</td>\n",
       "      <td>1695</td>\n",
       "      <td>2640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2650</td>\n",
       "      <td>4530x1775x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>福瑞迪</td>\n",
       "      <td>17</td>\n",
       "      <td>4530</td>\n",
       "      <td>1775</td>\n",
       "      <td>1460</td>\n",
       "      <td>2650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2650</td>\n",
       "      <td>4560x1775x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>福瑞迪</td>\n",
       "      <td>7</td>\n",
       "      <td>4560</td>\n",
       "      <td>1775</td>\n",
       "      <td>1460</td>\n",
       "      <td>2650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2670</td>\n",
       "      <td>4480x1855x1655</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX5</td>\n",
       "      <td>6</td>\n",
       "      <td>4480</td>\n",
       "      <td>1855</td>\n",
       "      <td>1655</td>\n",
       "      <td>2670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2700</td>\n",
       "      <td>4365x1780x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚K3S</td>\n",
       "      <td>12</td>\n",
       "      <td>4365</td>\n",
       "      <td>1780</td>\n",
       "      <td>1460</td>\n",
       "      <td>2700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2700</td>\n",
       "      <td>4600x1780x1445</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚K3</td>\n",
       "      <td>20</td>\n",
       "      <td>4600</td>\n",
       "      <td>1780</td>\n",
       "      <td>1445</td>\n",
       "      <td>2700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2700</td>\n",
       "      <td>4728x1820x1420</td>\n",
       "      <td>起亚</td>\n",
       "      <td>远舰</td>\n",
       "      <td>45</td>\n",
       "      <td>4728</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>2700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2700</td>\n",
       "      <td>4730x1890x1690</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX7</td>\n",
       "      <td>1</td>\n",
       "      <td>4730</td>\n",
       "      <td>1890</td>\n",
       "      <td>1690</td>\n",
       "      <td>2700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2700</td>\n",
       "      <td>4730x1890x1730</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚KX7</td>\n",
       "      <td>7</td>\n",
       "      <td>4730</td>\n",
       "      <td>1890</td>\n",
       "      <td>1730</td>\n",
       "      <td>2700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2770</td>\n",
       "      <td>4720x1815x1465</td>\n",
       "      <td>起亚</td>\n",
       "      <td>凯绅</td>\n",
       "      <td>24</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>2770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2795</td>\n",
       "      <td>4845x1830x1460</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚K5</td>\n",
       "      <td>40</td>\n",
       "      <td>4845</td>\n",
       "      <td>1830</td>\n",
       "      <td>1460</td>\n",
       "      <td>2795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1860x1475</td>\n",
       "      <td>起亚</td>\n",
       "      <td>起亚K5</td>\n",
       "      <td>13</td>\n",
       "      <td>4855</td>\n",
       "      <td>1860</td>\n",
       "      <td>1475</td>\n",
       "      <td>2805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2910</td>\n",
       "      <td>4930x1895x1760</td>\n",
       "      <td>起亚</td>\n",
       "      <td>嘉华</td>\n",
       "      <td>24</td>\n",
       "      <td>4930</td>\n",
       "      <td>1895</td>\n",
       "      <td>1760</td>\n",
       "      <td>2910</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   轴距[mm]       长×宽×高[mm] brand       style  factory car_length car_width  \\\n",
       "0    2345  3615x1605x1394    起亚         普莱特        6       3615      1605   \n",
       "1    2345  3935x1605x1465    起亚         普莱特        6       3935      1605   \n",
       "2    2400  4115x1620x1410    起亚         千里马       60       4115      1620   \n",
       "3    2500  4290x1695x1480    起亚          锐欧       18       4290      1695   \n",
       "4    2550  4096x1785x1663    起亚          秀尔       16       4096      1785   \n",
       "5    2570  4120x1700x1460    起亚        起亚K2       10       4120      1700   \n",
       "6    2570  4128x1700x1460    起亚        起亚K2        6       4128      1700   \n",
       "7    2570  4300x1700x1460    起亚          焕驰        5       4300      1700   \n",
       "8    2570  4370x1700x1460    起亚        起亚K2       15       4370      1700   \n",
       "9    2570  4378x1700x1460    起亚        起亚K2        7       4378      1700   \n",
       "10   2590  4270x1780x1630    起亚       起亚KX3        5       4270      1780   \n",
       "11   2590  4270x1780x1645    起亚       起亚KX3       12       4270      1780   \n",
       "12   2600  4240x1750x1505    起亚  起亚KX CROSS        2       4240      1750   \n",
       "13   2610  4500x1735x1470    起亚         赛拉图       48       4500      1735   \n",
       "14   2630  4350x1840x1730    起亚          狮跑       42       4350      1840   \n",
       "15   2640  4440x1855x1635    起亚          智跑        8       4440      1855   \n",
       "16   2640  4440x1855x1660    起亚          智跑       28       4440      1855   \n",
       "17   2640  4450x1855x1660    起亚          智跑       13       4450      1855   \n",
       "18   2640  4460x1850x1695    起亚          智跑        2       4460      1850   \n",
       "19   2650  4530x1775x1460    起亚         福瑞迪       17       4530      1775   \n",
       "20   2650  4560x1775x1460    起亚         福瑞迪        7       4560      1775   \n",
       "21   2670  4480x1855x1655    起亚       起亚KX5        6       4480      1855   \n",
       "22   2700  4365x1780x1460    起亚       起亚K3S       12       4365      1780   \n",
       "23   2700  4600x1780x1445    起亚        起亚K3       20       4600      1780   \n",
       "24   2700  4728x1820x1420    起亚          远舰       45       4728      1820   \n",
       "25   2700  4730x1890x1690    起亚       起亚KX7        1       4730      1890   \n",
       "26   2700  4730x1890x1730    起亚       起亚KX7        7       4730      1890   \n",
       "27   2770  4720x1815x1465    起亚          凯绅       24       4720      1815   \n",
       "28   2795  4845x1830x1460    起亚        起亚K5       40       4845      1830   \n",
       "29   2805  4855x1860x1475    起亚        起亚K5       13       4855      1860   \n",
       "30   2910  4930x1895x1760    起亚          嘉华       24       4930      1895   \n",
       "\n",
       "   car_height Wheelbase  \n",
       "0        1394      2345  \n",
       "1        1465      2345  \n",
       "2        1410      2400  \n",
       "3        1480      2500  \n",
       "4        1663      2550  \n",
       "5        1460      2570  \n",
       "6        1460      2570  \n",
       "7        1460      2570  \n",
       "8        1460      2570  \n",
       "9        1460      2570  \n",
       "10       1630      2590  \n",
       "11       1645      2590  \n",
       "12       1505      2600  \n",
       "13       1470      2610  \n",
       "14       1730      2630  \n",
       "15       1635      2640  \n",
       "16       1660      2640  \n",
       "17       1660      2640  \n",
       "18       1695      2640  \n",
       "19       1460      2650  \n",
       "20       1460      2650  \n",
       "21       1655      2670  \n",
       "22       1460      2700  \n",
       "23       1445      2700  \n",
       "24       1420      2700  \n",
       "25       1690      2700  \n",
       "26       1730      2700  \n",
       "27       1465      2770  \n",
       "28       1460      2795  \n",
       "29       1475      2805  \n",
       "30       1760      2910  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
